Categories

Versions

Declare Missing Value (In Database) (In-Database Processing)

Synopsis

Declares a missing numeric or nominal value on a selected subset.

Description

The given value will be replaced with NULL throughout the specified subset, so it will be treated as a missing value by subsequent operators.

Input

  • example set input

Output

  • example set output

Parameters

  • attribute_filter_type The condition specifies which attributes are selected or affected by this operator. Range: selection
  • attribute The attribute which should be chosen. Range: string
  • attributes The attribute which should be chosen. Range: string
  • regular_expression A regular expression for the names of the attributes which should be kept. Range: string
  • use_except_expression If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression. Range: boolean
  • except_regular_expression A regular expression for the names of the attributes which should be filtered out although matching the above regular expression. Range: string
  • value_type The value type of the attributes. Range: selection
  • use_value_type_exception If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type. Range: boolean
  • except_value_type Except this value type. Range: selection
  • block_type The block type of the attributes. Range: selection
  • use_block_type_exception If enabled, an exception to the specified block type might be specified. Range: boolean
  • except_block_type Except this block type. Range: selection
  • numeric_condition Parameter string for the condition, e.g. '>= 5' Range: string
  • invert_selection Indicates if only attributes should be accepted which would normally filtered. Range: boolean
  • mode Select the value type of the missing value Range: selection
  • numeric_value This parameter defines the missing numerical value Range: real
  • nominal_value This parameter defines the missing nominal value Range: string
  • expression_value This parameter defines the expression which if true equals the missing value Range: string